[dbo].[UserDefinedSingleInstanceProperty]

Property	Value
Created	3:09:25 PM Thursday, April 21, 2011
Last Modified	11:40:10 AM Monday, February 20, 2012

Property

Value

Created

3:09:25 PM Thursday, April 21, 2011

Last Modified

11:40:10 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$	TableName	[sys].[sysname]	256
$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$	PropertyName	[sys].[sysname]	256
$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$	RowID	nvarchar(16)	32
$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$	RowKey	uniqueidentifier	16
	PropertyIntValue	int	4
	PropertyDateTimeValue	datetime	8
	PropertyGuidValue	uniqueidentifier	16
	PropertyDecimalValue	decimal(38,12)	17
	PropertyBooleanValue	bit	1
	PropertyStringValue	nvarchar(400)	800

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$

TableName

[sys].[sysname]

256

$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$

PropertyName

[sys].[sysname]

256

$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$

RowID

nvarchar(16)

$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$

RowKey

uniqueidentifier

PropertyIntValue

int

PropertyDateTimeValue

datetime

PropertyGuidValue

uniqueidentifier

PropertyDecimalValue

decimal(38,12)

PropertyBooleanValue

bit

PropertyStringValue

nvarchar(400)

800

	Name	Columns
$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$	PK_UserDefinedSingleInstanceProperty	TableName, PropertyName, RowID, RowKey
	IX_UserDefinedSingleInstanceProperty_BooleanValue	PropertyBooleanValue
	IX_UserDefinedSingleInstanceProperty_DateTimeValue	PropertyDateTimeValue
	IX_UserDefinedSingleInstanceProperty_DecimalValue	PropertyDecimalValue
	IX_UserDefinedSingleInstanceProperty_GuidValue	PropertyGuidValue
	IX_UserDefinedSingleInstanceProperty_IntValue	PropertyIntValue
	IX_UserDefinedSingleInstanceProperty_StringValue	PropertyStringValue

Name

Columns

Unique

$Cluster Primary Key PK_UserDefinedSingleInstanceProperty: TableName\PropertyName\RowID\RowKey$

PK_UserDefinedSingleInstanceProperty

TableName, PropertyName, RowID, RowKey

IX_UserDefinedSingleInstanceProperty_BooleanValue

PropertyBooleanValue

IX_UserDefinedSingleInstanceProperty_DateTimeValue

PropertyDateTimeValue

IX_UserDefinedSingleInstanceProperty_DecimalValue

PropertyDecimalValue

IX_UserDefinedSingleInstanceProperty_GuidValue

PropertyGuidValue

IX_UserDefinedSingleInstanceProperty_IntValue

PropertyIntValue

IX_UserDefinedSingleInstanceProperty_StringValue

PropertyStringValue

SQL Script

CREATE TABLE [dbo].[UserDefinedSingleInstanceProperty]
(
[TableName] [sys].[sysname] NOT NULL,
[PropertyName] [sys].[sysname] NOT NULL,
[RowID] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RowKey] [uniqueidentifier] NOT NULL,
[PropertyIntValue] [int] NULL,
[PropertyDateTimeValue] [datetime] NULL,
[PropertyGuidValue] [uniqueidentifier] NULL,
[PropertyDecimalValue] [decimal] (38, 12) NULL,
[PropertyBooleanValue] [bit] NULL,
[PropertyStringValue] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UserDefinedSingleInstanceProperty] ADD CONSTRAINT [PK_UserDefinedSingleInstanceProperty] PRIMARY KEY CLUSTERED ([TableName], [PropertyName], [RowID], [RowKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedSingleInstanceProperty_BooleanValue] ON [dbo].[UserDefinedSingleInstanceProperty] ([PropertyBooleanValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedSingleInstanceProperty_DateTimeValue] ON [dbo].[UserDefinedSingleInstanceProperty] ([PropertyDateTimeValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedSingleInstanceProperty_DecimalValue] ON [dbo].[UserDefinedSingleInstanceProperty] ([PropertyDecimalValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedSingleInstanceProperty_GuidValue] ON [dbo].[UserDefinedSingleInstanceProperty] ([PropertyGuidValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedSingleInstanceProperty_IntValue] ON [dbo].[UserDefinedSingleInstanceProperty] ([PropertyIntValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedSingleInstanceProperty_StringValue] ON [dbo].[UserDefinedSingleInstanceProperty] ([PropertyStringValue]) ON [PRIMARY]
GO